create table if not exists d_rnt_rm_interface_d_#{PARTITION_DATE}
 (
id    varchar(40) ,
device_id    varchar(40) ,
if_index    bigint ,
if_descr    varchar(255) ,
if_type    bigint ,
if_mtu      bigint ,
if_speed    double(12,0) ,
if_phy_address    varchar(20) ,
if_admin_status    bigint ,
if_last_change    varchar(32) ,
if_oper_status    bigint ,
if_display_speed    varchar(20) ,
if_real_speed    double(15,0) ,
if_name    varchar(64) ,
ip_addr    varchar(20) ,
ip_netmask    varchar(20) ,
vlan_id    bigint ,
if_alias    varchar(64) ,
last_timestamp    datetime ,
instance    varchar(20) ,
objseverity    double(38,0) ,
is_used    varchar(1) ,
iscollect    double(15,5) ,
project_status    varchar(32) ,
if_vrf    varchar(64) ,
is_valid    bigint ,
direction    bigint ,
ctl_status_timestamp    datetime ,
open_collector    bigint ,
user_interface    bigint ,
user_updatetime    datetime 
)   compress(5, 5)  nolock ;